﻿CREATE TABLE [dbo].[SalesDetail_log] (
    [SalesNo]       VARCHAR (30)    NOT NULL,
    [LineNo]        VARCHAR (3)     NOT NULL,
    [ProductNo]     VARCHAR (10)    NOT NULL,
    [Qty]           NUMERIC (10, 2) NULL,
    [Price]         NUMERIC (10, 2) NULL,
    [Amount]        NUMERIC (15, 2) NULL,
    [DiscountRate]  NUMERIC (10, 4) NULL,
    [DiscountPrice] NUMERIC (10, 2) NULL,
    [DiscountAmt]   NUMERIC (15, 2) NULL,
    [TaxRate]       NUMERIC (10, 4) NULL,
    [TaxAmount]     NUMERIC (15, 2) NULL,
    [PriceInTax]    NUMERIC (10, 2) NULL,
    [AmountInTax]   NUMERIC (15, 2) NULL,
    [Remark]        VARCHAR (60)    NULL,
    [RecordID]      INT             NOT NULL,
    [UserID]        VARCHAR (60)    NOT NULL,
    [ModifyTime]    DATETIME        NOT NULL,
    [Action]        CHAR (1)        NOT NULL
);

